Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MySQL Tutorial
1) Aggregate Functions
2) Cast Functions Operators
3) Comparison Functions Operators
4) Control Flow Functions
5) Cursor
6) Data Dictionary
7) Data Types
8) Database
9) Date Time Functions
10) Encryption Compression Functions
11) Information Functions
12) Insert Update Delete
13) Introduction
14) Logic Operator
15) Math Numeric Functions
16) Miscellaneous Functions
17) MySQL Utilities
18) Privilege
19) Procedure Function
20) Regular Expressions
21) Select Query
22) String Functions
23) Subquery
24) Table
25) Table Join
26) Trigger
27) View

Subquery
1) A scalar subquery can be part of an expression
2) A subquery is a SELECT statement within another statement
3) An EXISTS subquery starts with SELECT , but it could begin with SELECT 5 or SELECT column1 or anything
4) Comparisons Using Subqueries
5) Correlated Subqueries
6) Delete clause with a subquery
7) Delete with subquery
8) Find all rows in a table containing a value that occurs twice in a given column
9) Get the Row Holding the Maximum of a Certain Column with sub query in where clause
10) Greater than ALL
11) NULL subquery with ALL
12) NULL Subquery with gradter than ()
13) Subqueries in the FROM clause
14) Subqueries with ALL
15) Subqueries with ANY
16) Subqueries with IN
17) Subqueries with SOME
18) The Rows Holding the Group-wise Maximum of a Certain Field
19) The Subquery as Scalar Operand
20) Update with subquery
21) Using EXISTS with subquery
22) Using Having to subquery
23) Using Join in the subquery
24) Using the aggregate function in subquery